﻿/*
Navicat MySQL Data Transfer

Source Server         : 打
Source Server Version : 50623
Source Host           : localhost:3306
Source Database       : bingo

Target Server Type    : MYSQL
Target Server Version : 50623
File Encoding         : 65001

Date: 2016-08-19 17:44:14
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for app_config
-- ----------------------------
DROP TABLE IF EXISTS `app_config`;
CREATE TABLE `app_config` (
  `Config_Key` varchar(50) DEFAULT NULL,
  `Config_Type` varchar(50) DEFAULT NULL,
  `Config_Value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of app_config
-- ----------------------------

-- ----------------------------
-- Table structure for association
-- ----------------------------
DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
  `Association_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_NO` int(10) DEFAULT NULL,
  `Nature` varchar(100) DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `Association_Grade` varchar(10) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `A_Size_NO` int(15) DEFAULT NULL,
  `Dept_Amount` int(2) DEFAULT NULL,
  `LOGO_Path` varchar(100) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Task_Status` varchar(60) DEFAULT NULL,
  `User_Password` varchar(100) DEFAULT NULL,
  `City_Code` int(15) DEFAULT NULL,
  `Provice_Code` int(15) DEFAULT NULL,
  `City_Name` varchar(200) DEFAULT NULL,
  `Provice_Name` varchar(200) DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `School_Grade_NO` int(15) DEFAULT NULL,
  `School_Grade_Name` varchar(100) DEFAULT NULL,
  `School_Name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Association_NO`),
  KEY `FKAssociatio856502` (`School_NO`),
  CONSTRAINT `FKAssociatio856502` FOREIGN KEY (`School_NO`) REFERENCES `school` (`School_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=40000000 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association
-- ----------------------------

-- ----------------------------
-- Table structure for association_student
-- ----------------------------
DROP TABLE IF EXISTS `association_student`;
CREATE TABLE `association_student` (
  `AssociationAssociation_NO` int(10) NOT NULL,
  `StudentStudent_NO` int(10) NOT NULL,
  `Status` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`AssociationAssociation_NO`,`StudentStudent_NO`),
  KEY `FKAssociatio686036` (`AssociationAssociation_NO`),
  KEY `FKAssociatio609651` (`StudentStudent_NO`),
  CONSTRAINT `FKAssociatio609651` FOREIGN KEY (`StudentStudent_NO`) REFERENCES `student` (`Student_NO`),
  CONSTRAINT `FKAssociatio686036` FOREIGN KEY (`AssociationAssociation_NO`) REFERENCES `association` (`Association_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association_student
-- ----------------------------

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `Company_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Company_Name` varchar(60) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `Password` varchar(60) DEFAULT NULL,
  `Web` varchar(100) DEFAULT NULL,
  `Nature` varchar(50) DEFAULT NULL,
  `C_Size` int(15) DEFAULT NULL,
  `Type` varchar(30) DEFAULT NULL,
  `Contact_NO` int(10) NOT NULL,
  `Contact_ID_NO` varchar(20) DEFAULT NULL,
  `License_NO` varchar(120) DEFAULT NULL,
  `License_Name` varchar(120) DEFAULT NULL,
  `License_EndDate` datetime DEFAULT NULL,
  `License_Address` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Grade` varchar(50) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `User_Password` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `CSize_Display_Name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Company_NO`),
  KEY `Company_Name` (`Company_Name`),
  KEY `FKCompany281990` (`Contact_NO`),
  CONSTRAINT `FKCompany281990` FOREIGN KEY (`Contact_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=20000000 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company
-- ----------------------------

-- ----------------------------
-- Table structure for event_log
-- ----------------------------
DROP TABLE IF EXISTS `event_log`;
CREATE TABLE `event_log` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Instance_ID` varchar(20) DEFAULT NULL,
  `Event_ID` varchar(45) DEFAULT NULL,
  `Action_Type` varchar(45) DEFAULT NULL,
  `Action_Object` varchar(45) DEFAULT NULL,
  `Action_Time` datetime DEFAULT NULL,
  `Operator` varchar(45) DEFAULT NULL,
  `Remark` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of event_log
-- ----------------------------

-- ----------------------------
-- Table structure for file_system
-- ----------------------------
DROP TABLE IF EXISTS `file_system`;
CREATE TABLE `file_system` (
  `File_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(50) DEFAULT NULL,
  `Type_Name` varchar(200) DEFAULT NULL,
  `InstanceID` varchar(30) DEFAULT NULL,
  `Path` varchar(500) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Ctreate_Time` datetime DEFAULT NULL,
  `Create_User` int(15) DEFAULT NULL,
  `Belong_NO` int(15) DEFAULT NULL,
  `Old_Name` varchar(300) DEFAULT NULL,
  `New_Name` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`File_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of file_system
-- ----------------------------

-- ----------------------------
-- Table structure for level_rule
-- ----------------------------
DROP TABLE IF EXISTS `level_rule`;
CREATE TABLE `level_rule` (
  `Rule_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Value_From` varchar(60) DEFAULT NULL,
  `Value_To` varchar(60) DEFAULT NULL,
  `Level` varchar(120) DEFAULT NULL,
  `Version` int(10) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Parent_No` int(10) DEFAULT NULL,
  `DisplayOrder` int(4) DEFAULT NULL,
  PRIMARY KEY (`Rule_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of level_rule
-- ----------------------------

-- ----------------------------
-- Table structure for money
-- ----------------------------
DROP TABLE IF EXISTS `money`;
CREATE TABLE `money` (
  `Role_NO` int(10) DEFAULT NULL,
  `Fun` varchar(30) DEFAULT NULL,
  `Count_Money` double DEFAULT NULL,
  `balance` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money
-- ----------------------------

-- ----------------------------
-- Table structure for money_log
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `NO` varchar(40) DEFAULT NULL,
  `Type` varchar(40) DEFAULT NULL,
  `Value_From` varchar(100) DEFAULT NULL,
  `Value_To` varchar(100) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `update_Time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money_log
-- ----------------------------

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `Project_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Project_Name` varchar(60) DEFAULT NULL,
  `Province` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  `Money` double DEFAULT NULL,
  `Money_Name` varchar(100) DEFAULT NULL,
  `Material` varchar(255) DEFAULT NULL,
  `Start_Time` datetime DEFAULT NULL,
  `End_Time` datetime DEFAULT NULL,
  `Entrants` int(11) DEFAULT NULL,
  `Entrants_Name` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Project_Require` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Book_Status` varchar(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Readers` int(10) DEFAULT NULL,
  `Liked_Count` int(11) DEFAULT NULL,
  `Belong_NO` int(10) DEFAULT NULL,
  `Belong_Type` varchar(30) DEFAULT NULL,
  `Belong_Contact_NO` int(10) DEFAULT NULL,
  `Nature` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Urgent_Remark` varchar(255) DEFAULT NULL,
  `Money_Status` varchar(70) DEFAULT NULL,
  PRIMARY KEY (`Project_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=30000000 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project
-- ----------------------------

-- ----------------------------
-- Table structure for project_extend
-- ----------------------------
DROP TABLE IF EXISTS `project_extend`;
CREATE TABLE `project_extend` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Code` int(20) DEFAULT NULL,
  `Value` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_extend
-- ----------------------------

-- ----------------------------
-- Table structure for project_field
-- ----------------------------
DROP TABLE IF EXISTS `project_field`;
CREATE TABLE `project_field` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(60) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `From_User` varchar(15) DEFAULT NULL,
  `To_User` varchar(15) DEFAULT NULL,
  `Field_Value` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  KEY `FKProject_Fi868447` (`Project_NO`),
  CONSTRAINT `FKProject_Fi868447` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_field
-- ----------------------------

-- ----------------------------
-- Table structure for project_items
-- ----------------------------
DROP TABLE IF EXISTS `project_items`;
CREATE TABLE `project_items` (
  `Project_NO` int(15) DEFAULT NULL,
  `Intention_Role` varchar(30) DEFAULT NULL,
  `Intention_Role_NO` varchar(15) DEFAULT NULL,
  `Intention_Contact_NO` varchar(15) DEFAULT NULL,
  `Status` varchar(15) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Remarks` varchar(255) DEFAULT NULL,
  `Is_Student_Confirm` int(1) DEFAULT NULL,
  `Student_Book_Remark` varchar(400) DEFAULT NULL,
  `Is_Company_Confirm` int(1) DEFAULT NULL,
  `Company_Book_Remark` varchar(400) DEFAULT NULL,
  `Urgent_Remark` varchar(400) DEFAULT NULL,
  `ContractNO` varchar(40) DEFAULT NULL,
  `Have_Offline_Team` int(1) DEFAULT NULL,
  `Have_Invoice` int(1) DEFAULT NULL,
  `Project_NO_Self` int(15) DEFAULT NULL,
  `Project_Self_Status` varchar(100) DEFAULT NULL,
  `Intention_Name` varchar(255) DEFAULT NULL,
  `Choose_Type` varchar(100) DEFAULT NULL,
  `Money_Status` varchar(100) DEFAULT NULL,
  `Project_Item_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Submit_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Project_Item_NO`),
  KEY `FKProject_It966760` (`Project_NO`),
  CONSTRAINT `FKProject_It966760` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_items
-- ----------------------------

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `School_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_Name` varchar(60) DEFAULT NULL,
  `Student_SIze` int(11) DEFAULT NULL,
  `Province` varchar(25) DEFAULT NULL,
  `City` varchar(25) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`School_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of school
-- ----------------------------

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `Student_NO` int(10) NOT NULL,
  `Student_LD_Number` varchar(16) DEFAULT NULL,
  `Student_Grade` varchar(10) DEFAULT NULL,
  `Ident_Type` varchar(20) DEFAULT NULL,
  `Ident_NO` varchar(20) DEFAULT NULL,
  `Bank_NO` varchar(30) DEFAULT NULL,
  `AliPay_NO` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Student_NO`),
  KEY `FKStudent321838` (`Student_NO`),
  CONSTRAINT `FKStudent321838` FOREIGN KEY (`Student_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `User_No` int(10) NOT NULL AUTO_INCREMENT,
  `User_Name` varchar(60) DEFAULT NULL,
  `NickName` varchar(60) DEFAULT NULL,
  `Password` varchar(180) DEFAULT NULL,
  `Phone` varchar(18) DEFAULT NULL,
  `QQ` varchar(20) DEFAULT NULL,
  `WeChart` varchar(30) DEFAULT NULL,
  `Role` varchar(30) DEFAULT NULL,
  `User_Type` varchar(15) DEFAULT NULL,
  `Sex` varchar(8) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=10000000 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------

-- ----------------------------
-- Table structure for user_validation
-- ----------------------------
DROP TABLE IF EXISTS `user_validation`;
CREATE TABLE `user_validation` (
  `Valid_ID` int(10) NOT NULL AUTO_INCREMENT,
  `User_ID` varchar(60) DEFAULT NULL,
  `Account_Type` varchar(10) DEFAULT NULL,
  `Account_Value` varchar(100) DEFAULT NULL,
  `Valid_Type` varchar(30) DEFAULT NULL,
  `Valid_No` varchar(300) DEFAULT NULL,
  `Valid_Status` varchar(20) DEFAULT NULL,
  `Created_Time` datetime DEFAULT NULL,
  `Updated_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Valid_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_validation
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;


INSERT INTO `level_rule` VALUES ('900000001', 'Nature', 'Active', '', '', '校级', null, '校级', null, null);
INSERT INTO `level_rule` VALUES ('900000002', 'Nature', 'Active', '', '', '院级', null, '院级', null, null);
INSERT INTO `level_rule` VALUES ('900000003', 'StudentInterval', 'Active', '0', '100', '1-100', null, '1-100', null, null);
INSERT INTO `level_rule` VALUES ('900000004', 'StudentInterval', 'Active', '101', '300', '101-300', null, '101-300', null, null);
INSERT INTO `level_rule` VALUES ('900000005', 'StudentInterval', 'Active', '301', '500', '301-500', null, '301-500', null, null);
INSERT INTO `level_rule` VALUES ('900000006', 'StudentInterval', 'Active', '501', '1000', '501-1000', null, '501-1000', null, null);
INSERT INTO `level_rule` VALUES ('900000007', 'StudentInterval', 'Active', '1001', '1500', '1001-1500', null, '1001-1500', null, null);
INSERT INTO `level_rule` VALUES ('900000008', 'StudentInterval', 'Active', '1501', '2500', '1501-2500', null, '1501-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000009', 'StudentInterval', 'Active', '2501', '3000', '2501-3000', null, '2501-3000', null, null);
INSERT INTO `level_rule` VALUES ('900000010', 'StudentInterval', 'Active', '3000', '3000000000', '3000以上', null, '3000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000011', 'SponsorMoney', 'Active', '500', '2500', '500-2500', null, '500-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000012', 'SponsorMoney', 'Active', '2501', '5000', '2501-5000', null, '2501-5000', null, null);
INSERT INTO `level_rule` VALUES ('900000013', 'SponsorMoney', 'Active', '5001', '7500', '5001-7500', null, '5001-7500', null, null);
INSERT INTO `level_rule` VALUES ('900000014', 'SponsorMoney', 'Active', '7501', '10000', '7501-10000', null, '7501-10000', null, null);
INSERT INTO `level_rule` VALUES ('900000015', 'SponsorMoney', 'Active', '10001', '15000', '10001-15000', null, '10001-15000', null, null);
INSERT INTO `level_rule` VALUES ('900000016', 'SponsorMoney', 'Active', '15001', '20000', '15001-20000', null, '15001-20000', null, null);
INSERT INTO `level_rule` VALUES ('900000017', 'SponsorMoney', 'Active', '20001', '25000', '20001-25000', null, '20001-25000', null, null);
INSERT INTO `level_rule` VALUES ('900000018', 'SponsorMoney', 'Active', '25001', '30000', '25001-30000', null, '25001-30000', null, null);
INSERT INTO `level_rule` VALUES ('900000019', 'SponsorMoney', 'Active', '30001', '50000', '30001-50000', null, '30001-50000', null, null);
INSERT INTO `level_rule` VALUES ('900000020', 'SponsorMoney', 'Active', '50001', '70000', '50001-70000', null, '50001-70000', null, null);
INSERT INTO `level_rule` VALUES ('900000021', 'SponsorMoney', 'Active', '70001', '100000', '70001-100000', null, '70001-100000', null, null);
INSERT INTO `level_rule` VALUES ('900000022', 'SponsorMoney', 'Active', '100001', '150000', '100001-150000', null, '100001-150000', null, null);
INSERT INTO `level_rule` VALUES ('900000023', 'SponsorMoney', 'Active', '150001', '200000', '150001-200000', null, '150001-200000', null, null);
INSERT INTO `level_rule` VALUES ('900000024', 'SponsorMoney', 'Active', '200000', '200000000', '200000以上', null, '200000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000025', 'StudentLevel', 'Active', '', '', '官方代理社团', null, '官方代理社团', null, null);
INSERT INTO `level_rule` VALUES ('900000026', 'StudentLevel', 'Active', '500', '5000000', '金牌社团', null, '金牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000027', 'StudentLevel', 'Active', '400', '500', '银牌社团', null, '银牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000028', 'StudentLevel', 'Active', '300', '400', '铜牌社团', null, '铜牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000029', 'StudentLevel', 'Active', '200', '300', '普通社团V3', null, '普通社团V3', null, null);
INSERT INTO `level_rule` VALUES ('900000030', 'StudentLevel', 'Active', '100', '200', '普通社团V2', null, '普通社团V2', null, null);
INSERT INTO `level_rule` VALUES ('900000031', 'StudentLevel', 'Active', '0', '100', '普通社团V1', null, '普通社团V1', null, null);
INSERT INTO `level_rule` VALUES ('900000033', 'SponsorMultiple', 'Active', '', '', '5', null, '5', null, null);
INSERT INTO `level_rule` VALUES ('900000034', 'CancelRemark', 'Active', '', '', '活动信息错误', null, '活动信息错误', null, null);
INSERT INTO `level_rule` VALUES ('900000035', 'CancelRemark', 'Active', '', '', '活动长时间没收到邀请', null, '活动长时间没收到邀请', null, null);
INSERT INTO `level_rule` VALUES ('900000036', 'CancelRemark', 'Active', '', '', '活动需要重新发布', null, '活动需要重新发布', null, null);
INSERT INTO `level_rule` VALUES ('900000037', 'CancelRemark', 'Active', '', '', '活动已达成目的', null, '活动已达成目的', null, null);
INSERT INTO `level_rule` VALUES ('900000038', 'CancelRemark', 'Active', '', '', '活动时间过期', null, '活动时间过期', null, null);
INSERT INTO `level_rule` VALUES ('900000039', 'CancelRemark', 'Active', '', '', '用户自主下架', null, '用户自主下架', null, null);
INSERT INTO `level_rule` VALUES ('900000040', 'ActivityType', 'Active', '', '', '招新类', null, '招新类', null, null);
INSERT INTO `level_rule` VALUES ('900000041', 'ActivityType', 'Active', '', '', '文艺类', null, '文艺类', null, null);
INSERT INTO `level_rule` VALUES ('900000042', 'ActivityType', 'Active', '', '', '表演类', null, '表演类', null, null);
INSERT INTO `level_rule` VALUES ('900000043', 'ActivityType', 'Active', '', '', '晚会类 ', null, '晚会类 ', null, null);
INSERT INTO `level_rule` VALUES ('900000044', 'ActivityType', 'Active', '', '', '体育类', null, '体育类', null, null);
INSERT INTO `level_rule` VALUES ('900000045', 'ActivityType', 'Active', '', '', '讲座类', null, '讲座类', null, null);
INSERT INTO `level_rule` VALUES ('900000046', 'ActivityType', 'Active', '', '', '比赛类', null, '比赛类', null, null);
INSERT INTO `level_rule` VALUES ('900000047', 'ActivityType', 'Active', '', '', '其它', null, '其它', null, null);
INSERT INTO `level_rule` VALUES ('900000048', 'AssosiationType', 'Active', '', '', '组织类-学生会', null, '组织类-学生会', null, null);
INSERT INTO `level_rule` VALUES ('900000049', 'AssosiationType', 'Active', '', '', '组织类-团委', null, '组织类-团委', null, null);
INSERT INTO `level_rule` VALUES ('900000050', 'AssosiationType', 'Active', '', '', '组织类-社团联合会', null, '组织类-社团联合会', null, null);
INSERT INTO `level_rule` VALUES ('900000051', 'AssosiationType', 'Active', '', '', '组织类-其他', null, '组织类-其他', null, null);
INSERT INTO `level_rule` VALUES ('900000052', 'AssosiationType', 'Active', '', '', '社团类-青年志愿者服务队', null, '社团类-青年志愿者服务队', null, null);
INSERT INTO `level_rule` VALUES ('900000053', 'AssosiationType', 'Active', '', '', '社团类-红十字会', null, '社团类-红十字会', null, null);
INSERT INTO `level_rule` VALUES ('900000054', 'AssosiationType', 'Active', '', '', '社团类-体育类社团', null, '社团类-体育类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000055', 'AssosiationType', 'Active', '', '', '社团类-棋牌类社团', null, '社团类-棋牌类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000056', 'AssosiationType', 'Active', '', '', '社团类-动漫社', null, '社团类-动漫社', null, null);
INSERT INTO `level_rule` VALUES ('900000057', 'AssosiationType', 'Active', '', '', '社团类-文娱类社团', null, '社团类-文娱类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000058', 'AssosiationType', 'Active', '', '', '社团类-兴趣类社团', null, '社团类-兴趣类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000059', 'AssosiationType', 'Active', '', '', '社团类-其他社团', null, '社团类-其他社团', null, null);
INSERT INTO `level_rule` VALUES ('900000060', 'CompanyMaterial', 'Active', '', '', '公司产品', null, '公司产品', null, null);
INSERT INTO `level_rule` VALUES ('900000061', 'CompanyMaterial', 'Active', '', '', '传单 ', null, '传单 ', null, null);
INSERT INTO `level_rule` VALUES ('900000062', 'CompanyMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000063', 'CompanyMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000064', 'CompanyMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000065', 'CompanyMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000066', 'CompanyMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000067', 'CompanyMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000068', 'CompanyMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000069', 'AssociationMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000070', 'AssociationMaterial', 'Active', '', '', '传单(黑白，彩色)', null, '传单(黑白，彩色)', null, null);
INSERT INTO `level_rule` VALUES ('900000071', 'AssociationMaterial', 'Active', '', '', 'KT板', null, 'KT板', null, null);
INSERT INTO `level_rule` VALUES ('900000072', 'AssociationMaterial', 'Active', '', '', '幕布', null, '幕布', null, null);
INSERT INTO `level_rule` VALUES ('900000073', 'AssociationMaterial', 'Active', '', '', '易拉宝', null, '易拉宝', null, null);
INSERT INTO `level_rule` VALUES ('900000074', 'AssociationMaterial', 'Active', '', '', '推头', null, '推头', null, null);
INSERT INTO `level_rule` VALUES ('900000075', 'AssociationMaterial', 'Active', '', '', '灯布', null, '灯布', null, null);
INSERT INTO `level_rule` VALUES ('900000076', 'AssociationMaterial', 'Active', '', '', '木构', null, '木构', null, null);
INSERT INTO `level_rule` VALUES ('900000077', 'AssociationMaterial', 'Active', '', '', '展位', null, '展位', null, null);
INSERT INTO `level_rule` VALUES ('900000078', 'AssociationMaterial', 'Active', '', '', '灯箱', null, '灯箱', null, null);
INSERT INTO `level_rule` VALUES ('900000079', 'AssociationMaterial', 'Active', '', '', '桁架', null, '桁架', null, null);
INSERT INTO `level_rule` VALUES ('900000080', 'AssociationMaterial', 'Active', '', '', '麦克风(耳麦，手麦，麦架)', null, '麦克风(耳麦，手麦，麦架)', null, null);
INSERT INTO `level_rule` VALUES ('900000081', 'AssociationMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000082', 'AssociationMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000083', 'AssociationMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000084', 'AssociationMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000085', 'AssociationMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000086', 'AssociationMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000087', 'CheckCompanyRejectedRemark', 'Active', '', '', '不存在您所输入的代理官口号令', null, '不存在您所输入的代理官口号令', null, null);
INSERT INTO `level_rule` VALUES ('900000088', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业全称与营业执照上的不一致', null, '企业全称与营业执照上的不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000089', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业地址不详细', null, '企业地址不详细', null, null);
INSERT INTO `level_rule` VALUES ('900000090', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业网址无法正常打开或网站内容不全', null, '企业网址无法正常打开或网站内容不全', null, null);
INSERT INTO `level_rule` VALUES ('900000091', 'CheckCompanyRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000092', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000093', 'CheckCompanyRejectedRemark', 'Active', '', '', '执照名称或注册号与营业执照不一致', null, '执照名称或注册号与营业执照不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000094', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的营业执照', null, '未上传正确的营业执照', null, null);
INSERT INTO `level_rule` VALUES ('900000095', 'CheckCompanyRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000096', 'CheckAssociationRejectedRemark', 'Active', '', '', '所属院系不正确或不存在', null, '所属院系不正确或不存在', null, null);
INSERT INTO `level_rule` VALUES ('900000097', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000098', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人学号与学生证不一致', null, '注册人学号与学生证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000099', 'CheckAssociationRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000100', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000101', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的学生证', null, '未上传正确的学生证', null, null);
INSERT INTO `level_rule` VALUES ('900000102', 'AssociationSize', 'Active', '1', '10', '1-10人', null, '1-10人', null, null);
INSERT INTO `level_rule` VALUES ('900000103', 'AssociationSize', 'Active', '11', '30', '11-30人', null, '11-30人', null, null);
INSERT INTO `level_rule` VALUES ('900000104', 'AssociationSize', 'Active', '31', '60', '31-60人', null, '31-60人', null, null);
INSERT INTO `level_rule` VALUES ('900000105', 'AssociationSize', 'Active', '61', '90', '61-90人', null, '61-90人', null, null);
INSERT INTO `level_rule` VALUES ('900000106', 'AssociationSize', 'Active', '91', '120', '91-120人', null, '91-120人', null, null);
INSERT INTO `level_rule` VALUES ('900000107', 'AssociationSize', 'Active', '121', '150', '121-150人', null, '121-150人', null, null);
INSERT INTO `level_rule` VALUES ('900000108', 'AssociationSize', 'Active', '151', '200', '151-200人', null, '151-200人', null, null);
INSERT INTO `level_rule` VALUES ('900000109', 'AssociationSize', 'Active', '201', '250', '201-250人', null, '201-250人', null, null);
INSERT INTO `level_rule` VALUES ('900000110', 'AssociationSize', 'Active', '251', '300', '251-300人', null, '251-300人', null, null);
INSERT INTO `level_rule` VALUES ('900000111', 'AssociationSize', 'Active', '300', '1000000', '300以上', null, '300以上', null, null);
